package com.color.admin.common.core.constant;

/**
 * @author HaiQiu
 * @date 2021/12/9
 * 常量数据库集合
 */
public class ConstantSql {


    /********************** RoleDDl ************** start ************/
    String SYS_ROLE_DDL = "CREATE TABLE `sys_role` (\n" +
            "  `id` varchar(255) NOT NULL COMMENT '主键ID',\n" +
            "  `role_name` varchar(20) DEFAULT NULL COMMENT '角色名称',\n" +
            "  `icon` varchar(255) DEFAULT NULL COMMENT '图标',\n" +
            "  `desc` varchar(500) DEFAULT NULL COMMENT '描述',\n" +
            "  `sort` int DEFAULT NULL COMMENT '排序',\n" +
            "  `active` bit(1) DEFAULT NULL COMMENT '激活禁用',\n" +
            "  `create_time` datetime DEFAULT NULL COMMENT '创建时间',\n" +
            "  `update_time` datetime DEFAULT NULL COMMENT '修改时间',\n" +
            "  PRIMARY KEY (`id`)\n" +
            ") ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;";
    /********************** RoleDDl ********** end ****************/
}
